--========================================================
--=                      INSERT                          =
--========================================================
insert into dbo.tbl_TienTe values('T01','USD','USD',21500,22000)
insert into dbo.tbl_TienTe values('T02','EUR','EUR',25500,26500)
insert into dbo.tbl_TienTe values('T03','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T04','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T05','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T06','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T07','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T08','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T09','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T10','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T11','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T12','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T13','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T14','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T15','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T16','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T17','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T18','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T19','YEN','YEN',19500,20000)
insert into dbo.tbl_TienTe values('T20','YEN','YEN',19500,20000)

select * from dbo.tbl_TienTe

GO

insert into dbo.tbl_ThongTinCongTy values('CT0001','Doanh Nghiep A','DOANHNGHIEPA','Dia Chi A','DIACHIA','01696667777','doanhnghiepA@aiti.com.vn','http:\\www.dnA.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0002','Doanh Nghiep B','DOANHNGHIEPB','Dia Chi B','DIACHIB','01696668888','doanhnghiepB@aiti.com.vn','http:\\www.dnB.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0003','Doanh Nghiep C','DOANHNGHIEPC','Dia Chi C','DIACHIC','01696669999','doanhnghiepC@aiti.com.vn','http:\\www.dnC.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0004','Doanh Nghiep D','DOANHNGHIEPD','Dia Chi D','DIACHID','01696661111','doanhnghiepD@aiti.com.vn','http:\\www.dnD.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0005','Doanh Nghiep E','DOANHNGHIEPE','Dia Chi E','DIACHIE','01696662222','doanhnghiepE@aiti.com.vn','http:\\www.dnE.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0006','Doanh Nghiep F','DOANHNGHIEPF','Dia Chi F','DIACHIF','01696663333','doanhnghiepF@aiti.com.vn','http:\\www.dnF.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0007','Doanh Nghiep G','DOANHNGHIEPG','Dia Chi G','DIACHIG','01696664444','doanhnghiepG@aiti.com.vn','http:\\www.dnG.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0008','Doanh Nghiep H','DOANHNGHIEPH','Dia Chi H','DIACHIH','01696665555','doanhnghiepH@aiti.com.vn','http:\\www.dnH.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0009','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0011','Doanh Nghiep A','DOANHNGHIEPA','Dia Chi A','DIACHIA','01696667777','doanhnghiepA@aiti.com.vn','http:\\www.dnA.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0022','Doanh Nghiep B','DOANHNGHIEPB','Dia Chi B','DIACHIB','01696668888','doanhnghiepB@aiti.com.vn','http:\\www.dnB.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0033','Doanh Nghiep C','DOANHNGHIEPC','Dia Chi C','DIACHIC','01696669999','doanhnghiepC@aiti.com.vn','http:\\www.dnC.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0044','Doanh Nghiep D','DOANHNGHIEPD','Dia Chi D','DIACHID','01696661111','doanhnghiepD@aiti.com.vn','http:\\www.dnD.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0055','Doanh Nghiep E','DOANHNGHIEPE','Dia Chi E','DIACHIE','01696662222','doanhnghiepE@aiti.com.vn','http:\\www.dnE.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0066','Doanh Nghiep F','DOANHNGHIEPF','Dia Chi F','DIACHIF','01696663333','doanhnghiepF@aiti.com.vn','http:\\www.dnF.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0077','Doanh Nghiep G','DOANHNGHIEPG','Dia Chi G','DIACHIG','01696664444','doanhnghiepG@aiti.com.vn','http:\\www.dnG.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0088','Doanh Nghiep H','DOANHNGHIEPH','Dia Chi H','DIACHIH','01696665555','doanhnghiepH@aiti.com.vn','http:\\www.dnH.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0099','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0111','Doanh Nghiep A','DOANHNGHIEPA','Dia Chi A','DIACHIA','01696667777','doanhnghiepA@aiti.com.vn','http:\\www.dnA.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0021','Doanh Nghiep B','DOANHNGHIEPB','Dia Chi B','DIACHIB','01696668888','doanhnghiepB@aiti.com.vn','http:\\www.dnB.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0031','Doanh Nghiep C','DOANHNGHIEPC','Dia Chi C','DIACHIC','01696669999','doanhnghiepC@aiti.com.vn','http:\\www.dnC.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0041','Doanh Nghiep D','DOANHNGHIEPD','Dia Chi D','DIACHID','01696661111','doanhnghiepD@aiti.com.vn','http:\\www.dnD.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0051','Doanh Nghiep E','DOANHNGHIEPE','Dia Chi E','DIACHIE','01696662222','doanhnghiepE@aiti.com.vn','http:\\www.dnE.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0061','Doanh Nghiep F','DOANHNGHIEPF','Dia Chi F','DIACHIF','01696663333','doanhnghiepF@aiti.com.vn','http:\\www.dnF.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0071','Doanh Nghiep G','DOANHNGHIEPG','Dia Chi G','DIACHIG','01696664444','doanhnghiepG@aiti.com.vn','http:\\www.dnG.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0081','Doanh Nghiep H','DOANHNGHIEPH','Dia Chi H','DIACHIH','01696665555','doanhnghiepH@aiti.com.vn','http:\\www.dnH.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0091','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0013','Doanh Nghiep A','DOANHNGHIEPA','Dia Chi A','DIACHIA','01696667777','doanhnghiepA@aiti.com.vn','http:\\www.dnA.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0023','Doanh Nghiep B','DOANHNGHIEPB','Dia Chi B','DIACHIB','01696668888','doanhnghiepB@aiti.com.vn','http:\\www.dnB.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0032','Doanh Nghiep C','DOANHNGHIEPC','Dia Chi C','DIACHIC','01696669999','doanhnghiepC@aiti.com.vn','http:\\www.dnC.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0043','Doanh Nghiep D','DOANHNGHIEPD','Dia Chi D','DIACHID','01696661111','doanhnghiepD@aiti.com.vn','http:\\www.dnD.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0053','Doanh Nghiep E','DOANHNGHIEPE','Dia Chi E','DIACHIE','01696662222','doanhnghiepE@aiti.com.vn','http:\\www.dnE.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0063','Doanh Nghiep F','DOANHNGHIEPF','Dia Chi F','DIACHIF','01696663333','doanhnghiepF@aiti.com.vn','http:\\www.dnF.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0073','Doanh Nghiep G','DOANHNGHIEPG','Dia Chi G','DIACHIG','01696664444','doanhnghiepG@aiti.com.vn','http:\\www.dnG.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0083','Doanh Nghiep H','DOANHNGHIEPH','Dia Chi H','DIACHIH','01696665555','doanhnghiepH@aiti.com.vn','http:\\www.dnH.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0990','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0991','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0992','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0993','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0994','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0995','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0996','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0997','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0998','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)
insert into dbo.tbl_ThongTinCongTy values('CT0999','Doanh Nghiep I','DOANHNGHIEPI','Dia Chi I','DIACHII','01696666666','doanhnghiepI@aiti.com.vn','http:\\www.dnI.com.vn','T01',50000)